We're going to take a look at a very closely related function to the Wii look up scan of the brother
or sister function of the view look up.
This is called H.
Look up now you might recall in the previous lecture the V look up V still stood for vertical.
In this case this is the H look up which stands for horizontal.
Now really the difference between the two really depends on the layout of your data.
Now let me just revisit that.
We look up for just a moment.
I mean a hop back to masterpoint list when you tell the Vlookup to go look into a list for a specific
value it looks into the first column vertically.
That's why it's called the V look up an H look up on the other hand horizontal will look into a list
such as this.
This is the master room inventory list.
This one will look horizontally through the first row of the list.
So just depends on how your data is laid out whether the value you're looking for is vertically It's
like a part of the records or perhaps it's a header a horizontal header at the top of your list that
you're looking for.
Other than that they're practically identical.
Take a look.
This is the H.
Look up.
So I'm going to go back to the lookup tab and what I'd like to do here is I want to capture the inventory
for the different warehouses for this product called XP 200.
Now on the master inventory list we've got all the different products.
There's the ACPI 200 and the different units.
The stock that we have for the different warehouses.
So here's the look up.
I mean we do warehouse inventory to number ones already done for you.
There's the example.
Now I'm inside of cell B-6.
So once again back to my former step back to look up and reference and I'm going to find H.
Look up there it is.
Now this opens up the argument window.
And if you take a moment look this over this window looks almost identical to the V look at that we
just got done talking about in the prior lecture.
So first thing you need to know what am I looking for.
Well my book of value is going to be XP 200 B-3.
The next thing I wants to know is great and looking for this but where am I going to look for it.
So the table array is going to be on the master inventory list and I'm going to go grab this list here
from a to down to G-5.
Now I've told the what it's looking for I told it where to find its memory.
H look up horizontal It's now traveling horizontally through the first row.
It finds Expwy 200 now wants to know which row row index number which row do you want to return back
.
Once I find it well for me there's Expwy 200 I want warehouse inventory number 2.
So I'm going to get row number 1 to 3.
I'll tell Ron next number is 3 and then range look up just like before it is optional.
But in most cases I use that I'm going to say false because I want it to find the exact match and that's
it.
And you know OK.
And there's my 110 warehouse inventory too.
Then if I hop over just to confirm XP 200 warehouse number two is 110.
That's it for little things.
Very very similar.
You master one of these you've mastered both of them and remember it just depends on how your data is
laid out really dictates which one you use.
Are you traveling vertically like a standard kind of set up of a list or are you looking at perhaps
headers that are horizontal along the top of your list.
Try this one out.
Open up the exercise file.
Hop over to to the oops the H look up function worksheet and find warehouse 2 inventory and warehouse 3
inventory.
Try this out